Tabela ICD

Definicja tabeli ICD

Name

ICD

Code

ICD

Comment

 


Lista kolumn tabeli ICD

Name

Code

ICDID

ICDID

ICDRevisionID

ICDRevisionID

Active

Active

Code

Code

FullName

FullName

ShortName

ShortName


Kolumna ICDID tabeli ICD

Definicja kolumny ICDID tabeli ICD

Name

ICDID

Code

ICDID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ICDRevisionID tabeli ICD

Definicja kolumny ICDRevisionID tabeli ICD

Name

ICDRevisionID

Code

ICDRevisionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Active tabeli ICD

Definicja kolumny Active tabeli ICD

Name

Active

Code

Active

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Code tabeli ICD

Definicja kolumny Code tabeli ICD

Name

Code

Code

Code

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna FullName tabeli ICD

Definicja kolumny FullName tabeli ICD

Name

FullName

Code

FullName

Data Type

VARCHAR2(1024)

Mandatory

No

Comment

 


Kolumna ShortName tabeli ICD

Definicja kolumny ShortName tabeli ICD

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Lista kluczy tabeli ICD

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ICD

Definicja klucza Identifier_1 tabeli ICD

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment